ClickHouse Stateless Tests (debug) [2/5] for PR #514
zookeeper_log.tsv.zst Commit check_status.tsv clickhouse-server.err.log clickhouse-server.log.zst coordination.tar garbage.log gdb.log metric_log.tsv.zst query_log.tsv.zst run.log stderr.log stdout.log test_result.txt test_results.tsv trace-log-CPU-flamegraph.tsv.zst trace-log-Memory-flamegraph.tsv.zst trace-log-Real-flamegraph.tsv.zst trace_log.tsv.zst transactions_info_log.tsv.zst Task (github actions) Job (github actions)
| Test name | Test status | Test time, sec. |
|---|---|---|
| 02901_parallel_replicas_rollup | NOT_FAILED | 58.53 |
This test passed. Update analyzer_tech_debt.txt. | ||
| 02845_threads_count_in_distributed_queries | FAIL | 53.49 |
2025-03-05 16:23:43 ConnectionRefusedError 2025-03-05 16:23:43 [Errno 111] Connection refused 2025-03-05 16:23:43 File "/usr/bin/clickhouse-test", line 1691, in run 2025-03-05 16:23:43 self._cleanup(result.status == TestStatus.OK) 2025-03-05 16:23:43 2025-03-05 16:23:43 File "/usr/bin/clickhouse-test", line 1754, in _cleanup 2025-03-05 16:23:43 self._cleanup_database(args, timeout) 2025-03-05 16:23:43 2025-03-05 16:23:43 File "/usr/bin/clickhouse-test", line 1788, in _cleanup_database 2025-03-05 16:23:43 clickhouse_execute( 2025-03-05 16:23:43 2025-03-05 16:23:43 File "/usr/bin/clickhouse-test", line 330, in clickhouse_execute 2025-03-05 16:23:43 return clickhouse_execute_http( 2025-03-05 16:23:43 2025-03-05 16:23:43 File "/usr/bin/clickhouse-test", line 311, in clickhouse_execute_http 2025-03-05 16:23:43 raise ex 2025-03-05 16:23:43 2025-03-05 16:23:43 File "/usr/bin/clickhouse-test", line 300, in clickhouse_execute_http 2025-03-05 16:23:43 client.request( 2025-03-05 16:23:43 2025-03-05 16:23:43 File "/usr/lib/python3.10/http/client.py", line 1283, in request 2025-03-05 16:23:43 self._send_request(method, url, body, headers, encode_chunked) 2025-03-05 16:23:43 2025-03-05 16:23:43 File "/usr/lib/python3.10/http/client.py", line 1329, in _send_request 2025-03-05 16:23:43 self.endheaders(body, encode_chunked=encode_chunked) 2025-03-05 16:23:43 2025-03-05 16:23:43 File "/usr/lib/python3.10/http/client.py", line 1278, in endheaders 2025-03-05 16:23:43 self._send_output(message_body, encode_chunked=encode_chunked) 2025-03-05 16:23:43 2025-03-05 16:23:43 File "/usr/lib/python3.10/http/client.py", line 1038, in _send_output 2025-03-05 16:23:43 self.send(msg) 2025-03-05 16:23:43 2025-03-05 16:23:43 Settings used in the test: --max_insert_threads 0 --group_by_two_level_threshold 374266 --group_by_two_level_threshold_bytes 1 --distributed_aggregation_memory_efficient 0 --fsync_metadata 0 --output_format_parallel_formatting 0 --input_format_parallel_parsing 1 --min_chunk_bytes_for_parallel_parsing 4968498 --max_read_buffer_size 552656 --prefer_localhost_replica 0 --max_block_size 95444 --max_threads 63 --optimize_append_index 0 --optimize_if_chain_to_multiif 1 --optimize_if_transform_strings_to_enum 1 --optimize_read_in_order 0 --optimize_or_like_chain 1 --optimize_substitute_columns 1 --enable_multiple_prewhere_read_steps 0 --read_in_order_two_level_merge_threshold 88 --optimize_aggregation_in_order 0 --aggregation_in_order_max_block_bytes 2344919 --use_uncompressed_cache 1 --min_bytes_to_use_direct_io 10737418240 --min_bytes_to_use_mmap_io 1 --local_filesystem_read_method pread_threadpool --remote_filesystem_read_method read --local_filesystem_read_prefetch 0 --filesystem_cache_segments_batch_size 3 --read_from_filesystem_cache_if_exists_otherwise_bypass_cache 1 --throw_on_error_from_cache_on_write_operations 1 --remote_filesystem_read_prefetch 1 --allow_prefetched_read_pool_for_remote_filesystem 0 --filesystem_prefetch_max_memory_usage 32Mi --filesystem_prefetches_limit 10 --filesystem_prefetch_min_bytes_for_single_read_task 16Mi --filesystem_prefetch_step_marks 0 --filesystem_prefetch_step_bytes 0 --compile_aggregate_expressions 0 --compile_sort_description 0 --merge_tree_coarse_index_granularity 27 --optimize_distinct_in_order 1 --max_bytes_before_external_sort 10737418240 --max_bytes_before_external_group_by 10737418240 --max_bytes_before_remerge_sort 1168677355 --min_compress_block_size 1557228 --max_compress_block_size 1426894 --merge_tree_compact_parts_min_granules_to_multibuffer_read 64 --optimize_sorting_by_input_stream_properties 0 --http_response_buffer_size 9742796 --http_wait_end_of_query True --enable_memory_bound_merging_of_aggregation_results 1 --min_count_to_compile_expression 0 --min_count_to_compile_aggregate_expression 0 --min_count_to_compile_sort_description 0 --session_timezone Africa/Juba --prefer_warmed_unmerged_parts_seconds 4 --use_page_cache_for_disks_without_file_cache True --page_cache_inject_eviction False --merge_tree_read_split_ | ||
| 02815_fix_not_found_constants_col_in_block | FAIL | 23.97 |
2025-03-05 16:23:43 ConnectionRefusedError 2025-03-05 16:23:43 [Errno 111] Connection refused 2025-03-05 16:23:43 File "/usr/bin/clickhouse-test", line 1691, in run 2025-03-05 16:23:43 self._cleanup(result.status == TestStatus.OK) 2025-03-05 16:23:43 2025-03-05 16:23:43 File "/usr/bin/clickhouse-test", line 1754, in _cleanup 2025-03-05 16:23:43 self._cleanup_database(args, timeout) 2025-03-05 16:23:43 2025-03-05 16:23:43 File "/usr/bin/clickhouse-test", line 1788, in _cleanup_database 2025-03-05 16:23:43 clickhouse_execute( 2025-03-05 16:23:43 2025-03-05 16:23:43 File "/usr/bin/clickhouse-test", line 330, in clickhouse_execute 2025-03-05 16:23:43 return clickhouse_execute_http( 2025-03-05 16:23:43 2025-03-05 16:23:43 File "/usr/bin/clickhouse-test", line 311, in clickhouse_execute_http 2025-03-05 16:23:43 raise ex 2025-03-05 16:23:43 2025-03-05 16:23:43 File "/usr/bin/clickhouse-test", line 300, in clickhouse_execute_http 2025-03-05 16:23:43 client.request( 2025-03-05 16:23:43 2025-03-05 16:23:43 File "/usr/lib/python3.10/http/client.py", line 1283, in request 2025-03-05 16:23:43 self._send_request(method, url, body, headers, encode_chunked) 2025-03-05 16:23:43 2025-03-05 16:23:43 File "/usr/lib/python3.10/http/client.py", line 1329, in _send_request 2025-03-05 16:23:43 self.endheaders(body, encode_chunked=encode_chunked) 2025-03-05 16:23:43 2025-03-05 16:23:43 File "/usr/lib/python3.10/http/client.py", line 1278, in endheaders 2025-03-05 16:23:43 self._send_output(message_body, encode_chunked=encode_chunked) 2025-03-05 16:23:43 2025-03-05 16:23:43 File "/usr/lib/python3.10/http/client.py", line 1038, in _send_output 2025-03-05 16:23:43 self.send(msg) 2025-03-05 16:23:43 2025-03-05 16:23:43 Settings used in the test: --max_insert_threads 0 --group_by_two_level_threshold 706254 --group_by_two_level_threshold_bytes 16429236 --distributed_aggregation_memory_efficient 1 --fsync_metadata 1 --output_format_parallel_formatting 1 --input_format_parallel_parsing 0 --min_chunk_bytes_for_parallel_parsing 11432639 --max_read_buffer_size 652983 --prefer_localhost_replica 1 --max_block_size 65025 --max_threads 29 --optimize_append_index 1 --optimize_if_chain_to_multiif 1 --optimize_if_transform_strings_to_enum 1 --optimize_read_in_order 0 --optimize_or_like_chain 1 --optimize_substitute_columns 1 --enable_multiple_prewhere_read_steps 0 --read_in_order_two_level_merge_threshold 78 --optimize_aggregation_in_order 1 --aggregation_in_order_max_block_bytes 20607348 --use_uncompressed_cache 0 --min_bytes_to_use_direct_io 7193118042 --min_bytes_to_use_mmap_io 1254810288 --local_filesystem_read_method io_uring --remote_filesystem_read_method read --local_filesystem_read_prefetch 1 --filesystem_cache_segments_batch_size 3 --read_from_filesystem_cache_if_exists_otherwise_bypass_cache 0 --throw_on_error_from_cache_on_write_operations 1 --remote_filesystem_read_prefetch 0 --allow_prefetched_read_pool_for_remote_filesystem 0 --filesystem_prefetch_max_memory_usage 64Mi --filesystem_prefetches_limit 0 --filesystem_prefetch_min_bytes_for_single_read_task 1Mi --filesystem_prefetch_step_marks 0 --filesystem_prefetch_step_bytes 100Mi --compile_aggregate_expressions 0 --compile_sort_description 0 --merge_tree_coarse_index_granularity 12 --optimize_distinct_in_order 0 --max_bytes_before_external_sort 10737418240 --max_bytes_before_external_group_by 10737418240 --max_bytes_before_remerge_sort 2549999021 --min_compress_block_size 1755003 --max_compress_block_size 2303451 --merge_tree_compact_parts_min_granules_to_multibuffer_read 112 --optimize_sorting_by_input_stream_properties 1 --http_response_buffer_size 3661031 --http_wait_end_of_query False --enable_memory_bound_merging_of_aggregation_results 0 --min_count_to_compile_expression 3 --min_count_to_compile_aggregate_expression 0 --min_count_to_compile_sort_description 0 --session_timezone America/Hermosillo --prefer_warmed_unmerged_parts_seconds 0 --use_page_cache_for_disks_without_file_cache True --page_cache_inject_eviction False --me | ||
| 03164_create_as_default | OK | 3.16 |
| 03164_analyzer_rewrite_aggregate_function_with_if | OK | 3.48 |
| 03215_udf_with_union | OK | 3.5 |
| 03165_order_by_duplicate | OK | 3.51 |
| 03231_pr_duplicate_announcement | OK | 4.17 |
| 03228_virtual_column_merge_dist | OK | 4.21 |
| 03149_analyzer_window_redefinition | OK | 3.52 |
| 03033_analyzer_parametrized_view_alias | OK | 3.56 |
| 03036_prewhere_lambda_function | OK | 3.71 |
| 03031_low_cardinality_logical_error | OK | 3.55 |
| 03032_scalars_create_as_select | OK | 3.61 |
| 03198_settings_in_csv_tsv_schema_cache | OK | 9.26 |
| 03015_aggregator_empty_data_multiple_blocks | OK | 3.53 |
| 03020_order_by_SimpleAggregateFunction | OK | 4.34 |
| 03017_analyzer_groupby_fuzz_61600 | OK | 3.79 |
| 03030_system_flush_distributed_settings | OK | 4.9 |
| 03013_repeat_with_nonnative_integers | OK | 3.53 |
| 03021_output_format_tty | OK | 7.43 |
| 03013_hop_infinite_loop | OK | 3.19 |
| 03010_virtual_memory_mappings_asynchronous_metrics | OK | 3.31 |
| 03013_test_part_level_is_reset_attach_from_disk_mt | OK | 4.04 |
| 03010_file_log_large_poll_batch_size | OK | 3.31 |
| 03010_sum_to_to_count_if_nullable | OK | 4.55 |
| 03010_view_prewhere_in | OK | 3.67 |
| 03008_index_small | OK | 3.59 |
| 03007_column_nullable_uninitialzed_value | OK | 3.84 |
| 03006_parallel_replicas_prewhere | OK | 4.02 |
| 03006_mv_deduplication_throw_if_async_insert | OK | 3.84 |
| 03005_input_function_in_join | OK | 3.67 |
| 03000_minmax_index_first | OK | 3.69 |
| 02998_projection_after_attach_partition | OK | 4.04 |
| 02998_analyzer_prewhere_report | OK | 3.54 |
| 02997_projections_formatting | OK | 2.59 |
| 02996_nullable_arrayReduce | OK | 3.95 |
| 02994_sanity_check_settings | OK | 4.21 |
| 02994_inconsistent_formatting | OK | 3.69 |
| 02992_settings_overflow | OK | 3.25 |
| 03006_async_insert_deadlock_log | OK | 17.23 |
| 03145_non_loaded_projection_backup | OK | 32.33 |
| 02984_topk_empty_merge | OK | 3.55 |
| 02985_minmax_index_aggregate_function | OK | 4.11 |
| 02989_join_using_parent_scope | OK | 5.97 |
| 02982_dont_infer_exponent_floats | OK | 3.44 |
| 02981_variant_type_function | OK | 3.68 |
| 02982_minmax_nan_null_order | OK | 4.78 |
| 02973_block_number_sparse_serialization_and_mutation | OK | 4.64 |
| 02971_limit_by_distributed | OK | 3.91 |
| 02968_mysql_show_warnings | OK | 4.41 |
| 02967_mysql_settings_override | OK | 4.56 |
| 02965_projection_with_partition_pruning | OK | 3.53 |
| 03001_backup_matview_after_modify_query | OK | 33.71 |
| 02972_insert_deduplication_token_hierarchical_inserts_views | OK | 13.6 |
| 02962_analyzer_const_in_count_distinct | OK | 3.44 |
| 02963_single_value_destructor | OK | 6.03 |
| 02959_system_database_engines | OK | 3.46 |
| 02958_transform_enum | OK | 3.57 |
| 02954_analyzer_fuzz_i57086 | OK | 3.69 |
| 02953_slow_create_view | OK | 3.86 |
| 02952_conjunction_optimization | OK | 3.99 |
| 02950_part_offset_as_primary_key | OK | 4.51 |
| 02950_reading_array_tuple_subcolumns | OK | 4.86 |
| 02949_parallel_replicas_scalar_subquery_big_integer | OK | 3.77 |
| 02947_merge_tree_index_table_2 | OK | 1.54 |
| 02947_parallel_replicas_remote | OK | 3.76 |
| 02961_output_format_compress_params | OK | 17.03 |
| 02935_parallel_replicas_settings | OK | 13.94 |
| 02994_libarchive_compression | OK | 59.96 |
| 02935_http_content_type_with_http_headers_progress | OK | 16.86 |
| 03174_split_parts_ranges_into_intersecting_and_non_intersecting_final_and_read-in-order_bug | OK | 88.62 |
| 02923_explain_expired_context | OK | 3.58 |
| 02923_cte_equality_disjunction | OK | 3.41 |
| 03001_matview_columns_after_modify_query | OK | 74.84 |
| 02932_idna | OK | 7.43 |
| 02932_set_ttl_where | OK | 12.26 |
| 02922_server_exit_code | OK | 5.0 |
| 02919_segfault_nullable_materialized_update | OK | 4.01 |
| 02918_analyzer_to_ast_crash | OK | 3.27 |
| 02916_set_formatting | OK | 2.88 |
| 02922_respect_nulls_extensive | OK | 6.23 |
| 02919_ddsketch_quantile | OK | 4.85 |
| 02935_external_table_enum_type | OK | 31.72 |
| 02916_csv_infer_numbers_from_strings | OK | 3.6 |
| 02915_analyzer_fuzz_5 | OK | 3.81 |
| 02915_sleep_large_uint | OK | 3.75 |
| 02911_analyzer_explain_estimate | OK | 3.56 |
| 02916_date_text_parsing | OK | 5.08 |
| 02914_t64_buffer_overflow | OK | 4.17 |
| 02910_nullable_enum_cast | OK | 3.51 |
| 02911_arrow_large_list | OK | 5.29 |
| 02969_auto_format_detection | OK | 65.06 |
| 02909_settings_in_json_schema_cache | OK | 5.28 |
| 02902_json_skip_null_values | OK | 3.97 |
| 02902_add_scalar_in_all_case | OK | 3.95 |
| 02905_structure_to_schema_bad_names | OK | 7.68 |
| 02907_backup_mv_with_no_inner_table | OK | 24.36 |
| 02896_illegal_sampling | OK | 3.29 |
| 02896_multiple_OR | OK | 3.93 |
| 02903_rmt_retriable_merge_exception | OK | 29.21 |
| 02895_cast_operator_bug | OK | 3.49 |
| 02889_datetime64_from_string | OK | 3.9 |
| 02896_leading_zeroes_no_octal | OK | 9.81 |
| 02889_print_pretty_type_names | OK | 3.45 |
| 02941_variant_type_2 | OK | 87.86 |
| 02888_attach_partition_from_different_tables | OK | 4.36 |
| 02887_format_readable_timedelta_subseconds | OK | 3.68 |
| 02886_missed_json_subcolumns | OK | 4.3 |
| 02886_binary_like | OK | 4.27 |
| 02884_interval_operator_support_plural_literal | OK | 4.15 |
| 02884_string_distance_function | OK | 5.52 |
| 02907_preferred_optimize_projection_name | OK | 65.37 |
| 02896_dwarf_format | OK | 56.09 |
| 02882_clickhouse_keeper_client_no_confirmation | OK | 4.42 |
| 02883_read_in_reverse_order_virtual_column | OK | 9.67 |
| 02882_replicated_fetch_checksums_doesnt_match | OK | 9.87 |
| 02884_async_insert_native_protocol_4 | OK | 20.98 |
| 02875_parallel_replicas_cluster_all_replicas | OK | 6.64 |
| 02874_json_merge_patch_function_test | OK | 4.09 |
| 02868_operator_is_not_distinct_from_priority | OK | 3.75 |
| 02870_per_column_settings | OK | 5.11 |
| 02845_join_on_cond_sparse | OK | 3.85 |
| 02873_s3_presigned_url_and_url_with_special_characters | OK | 11.73 |
| 02845_arrayShiftRotate | OK | 5.32 |
| 02875_merge_engine_set_index | OK | 18.36 |
| 02844_distributed_virtual_columns | OK | 3.61 |
| 02844_table_function_url_filter_by_virtual_columns | OK | 6.67 |
| 02843_date_predicate_optimizations_bugs | OK | 3.36 |
| 02844_tsv_carriage_return_parallel_parsing | OK | 7.72 |
| 02842_capn_proto_outfile_without_schema | OK | 5.29 |
| 02911_backup_restore_keeper_map | OK | 101.67 |
| 02834_alter_exception | OK | 10.93 |
| 02833_std_alias | OK | 7.72 |
| 02843_context_has_expired | OK | 13.26 |
| 02835_nested_array_lowcardinality | OK | 13.0 |
| 02899_restore_parts_replicated_merge_tree | OK | 94.92 |
| 02817_group_array_moving_zero_window_size | OK | 3.21 |
| 02816_check_projection_metadata | OK | 3.37 |
| 02831_ast_fuzz_asan_join | OK | 3.52 |
| Tests are not finished | FAIL | 0.0 |
